Overview

Brought to you by YData

Dataset statistics

Number of variables	24
Number of observations	28236
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	12.4 MiB
Average record size in memory	462.0 B

Variable types

Text	2
DateTime	1
Categorical	6
Numeric	12
Boolean	3

Alerts

`post_hour` has constant value "9"	Constant
`caption_length` is highly overall correlated with `long_caption`	High correlation
`engagement_rate` is highly overall correlated with `followers_count_before_post` and 1 other fields	High correlation
`follower_bucket` is highly overall correlated with `followers_count_before_post`	High correlation
`followers_count_before_post` is highly overall correlated with `engagement_rate` and 1 other fields	High correlation
`has_high_hashtags` is highly overall correlated with `hashtags_count`	High correlation
`hashtags_count` is highly overall correlated with `has_high_hashtags`	High correlation
`high_intent_engagement` is highly overall correlated with `saves`	High correlation
`impressions` is highly overall correlated with `reach`	High correlation
`is_weekend` is highly overall correlated with `post_day`	High correlation
`likes` is highly overall correlated with `engagement_rate`	High correlation
`long_caption` is highly overall correlated with `caption_length`	High correlation
`post_day` is highly overall correlated with `is_weekend`	High correlation
`reach` is highly overall correlated with `impressions`	High correlation
`saves` is highly overall correlated with `high_intent_engagement`	High correlation
`long_caption` is highly imbalanced (63.9%)	Imbalance
`follower_bucket` is uniformly distributed	Uniform
`post_id` has unique values	Unique
`hashtags_count` has 957 (3.4%) zeros	Zeros

Reproduction

Analysis started	2025-12-27 13:04:01.486163
Analysis finished	2025-12-27 13:04:20.435753
Duration	18.95 seconds
Software version	ydata-profiling vv4.12.2
Download configuration	config.json

post_id
Text

Unique

Distinct	28236
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Length

Max length	9
Median length	9
Mean length	9
Min length	9

Characters and Unicode

Total characters	254124
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	28236 ?
Unique (%)	100.0%

Sample

1st row	IG0013402
2nd row	IG0010751
3rd row	IG0013361
4th row	IG0027034
5th row	IG0022212

Value	Count	Frequency (%)
ig0013402	1	< 0.1%
ig0011970	1	< 0.1%
ig0022212	1	< 0.1%
ig0027062	1	< 0.1%
ig0021589	1	< 0.1%
ig0012768	1	< 0.1%
ig0000281	1	< 0.1%
ig0013175	1	< 0.1%
ig0000512	1	< 0.1%
ig0021320	1	< 0.1%
Other values (28226)	28226	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
0	77131	30.4%
I	28236	11.1%
G	28236	11.1%
2	20749	8.2%
1	20711	8.1%
5	11315	4.5%
6	11313	4.5%
9	11293	4.4%
4	11289	4.4%
8	11286	4.4%
Other values (2)	22565	8.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	197652	77.8%
Uppercase Letter	56472	22.2%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	77131	39.0%
2	20749	10.5%
1	20711	10.5%
5	11315	5.7%
6	11313	5.7%
9	11293	5.7%
4	11289	5.7%
8	11286	5.7%
3	11283	5.7%
7	11282	5.7%

Uppercase Letter

Value	Count	Frequency (%)
I	28236	50.0%
G	28236	50.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	197652	77.8%
Latin	56472	22.2%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	77131	39.0%
2	20749	10.5%
1	20711	10.5%
5	11315	5.7%
6	11313	5.7%
9	11293	5.7%
4	11289	5.7%
8	11286	5.7%
3	11283	5.7%
7	11282	5.7%

Latin

Value	Count	Frequency (%)
I	28236	50.0%
G	28236	50.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	254124	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	77131	30.4%
I	28236	11.1%
G	28236	11.1%
2	20749	8.2%
1	20711	8.1%
5	11315	4.5%
6	11313	4.5%
9	11293	4.4%
4	11289	4.4%
8	11286	4.4%
Other values (2)	22565	8.9%

upload_date
Date

Distinct	366
Distinct (%)	1.3%
Missing	0
Missing (%)	0.0%
Memory size	441.2 KiB

Minimum	2024-11-19 09:25:22.954916
Maximum	2025-11-19 09:25:22.954916
Invalid dates	0
Invalid dates (%)	0.0%

Histogram with fixed size bins (bins=50)

media_type
Categorical

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

Reel	7085
Carousel	7082
Video	7062
Photo	7007

Length

Max length	8
Median length	5
Mean length	5.5015229
Min length	4

Characters and Unicode

Total characters	155341
Distinct characters	15
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Reel
2nd row	Video
3rd row	Video
4th row	Video
5th row	Carousel

Common Values

Value	Count	Frequency (%)
Reel	7085	25.1%
Carousel	7082	25.1%
Video	7062	25.0%
Photo	7007	24.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
reel	7085	25.1%
carousel	7082	25.1%
video	7062	25.0%
photo	7007	24.8%

Most occurring characters

Value	Count	Frequency (%)
e	28314	18.2%
o	28158	18.1%
l	14167	9.1%
R	7085	4.6%
C	7082	4.6%
a	7082	4.6%
r	7082	4.6%
u	7082	4.6%
s	7082	4.6%
V	7062	4.5%
Other values (5)	35145	22.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	127105	81.8%
Uppercase Letter	28236	18.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	28314	22.3%
o	28158	22.2%
l	14167	11.1%
a	7082	5.6%
r	7082	5.6%
u	7082	5.6%
s	7082	5.6%
i	7062	5.6%
d	7062	5.6%
h	7007	5.5%

Uppercase Letter

Value	Count	Frequency (%)
R	7085	25.1%
C	7082	25.1%
V	7062	25.0%
P	7007	24.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	155341	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	28314	18.2%
o	28158	18.1%
l	14167	9.1%
R	7085	4.6%
C	7082	4.6%
a	7082	4.6%
r	7082	4.6%
u	7082	4.6%
s	7082	4.6%
V	7062	4.5%
Other values (5)	35145	22.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	155341	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	28314	18.2%
o	28158	18.1%
l	14167	9.1%
R	7085	4.6%
C	7082	4.6%
a	7082	4.6%
r	7082	4.6%
u	7082	4.6%
s	7082	4.6%
V	7062	4.5%
Other values (5)	35145	22.6%

likes
Real number (ℝ)

High correlation

Distinct	26335
Distinct (%)	93.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98181.831

Minimum	7
Maximum	200000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	7
5-th percentile	9485.5
Q1	48112.25
median	96940.5
Q3	147928.75
95-th percentile	189716.5
Maximum	200000
Range	199993
Interquartile range (IQR)	99816.5

Descriptive statistics

Standard deviation	57878.895
Coefficient of variation (CV)	0.58950719
Kurtosis	-1.1981412
Mean	98181.831
Median Absolute Deviation (MAD)	49814.5
Skewness	0.048168889
Sum	2.7722622 × 10⁹
Variance	3.3499665 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82010	4	< 0.1%
194623	4	< 0.1%
61217	4	< 0.1%
86010	4	< 0.1%
18648	4	< 0.1%
97189	4	< 0.1%
4149	4	< 0.1%
31311	3	< 0.1%
60271	3	< 0.1%
29919	3	< 0.1%
Other values (26325)	28199	99.9%

Value	Count	Frequency (%)
7	1	< 0.1%
9	2	< 0.1%
42	1	< 0.1%
53	1	< 0.1%
66	1	< 0.1%
67	1	< 0.1%
77	1	< 0.1%
95	1	< 0.1%
104	1	< 0.1%
108	1	< 0.1%

Value	Count	Frequency (%)
200000	1	< 0.1%
199994	1	< 0.1%
199980	1	< 0.1%
199979	1	< 0.1%
199973	1	< 0.1%
199961	1	< 0.1%
199960	1	< 0.1%
199957	1	< 0.1%
199953	1	< 0.1%
199952	1	< 0.1%

comments
Real number (ℝ)

Distinct	9416
Distinct (%)	33.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5014.3199

Minimum	0
Maximum	10000
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0
5-th percentile	499
Q1	2522.75
median	5035
Q3	7520
95-th percentile	9499.25
Maximum	10000
Range	10000
Interquartile range (IQR)	4997.25

Descriptive statistics

Standard deviation	2890.6387
Coefficient of variation (CV)	0.57647672
Kurtosis	-1.2021642
Mean	5014.3199
Median Absolute Deviation (MAD)	2497
Skewness	-0.0078979804
Sum	1.4158434 × 10⁸
Variance	8355791.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8617	10	< 0.1%
2643	9	< 0.1%
1458	9	< 0.1%
1961	9	< 0.1%
2990	9	< 0.1%
5857	9	< 0.1%
4407	9	< 0.1%
2982	9	< 0.1%
4888	9	< 0.1%
6357	9	< 0.1%
Other values (9406)	28145	99.7%

Value	Count	Frequency (%)
0	3	< 0.1%
1	2	< 0.1%
2	3	< 0.1%
3	3	< 0.1%
4	2	< 0.1%
5	5	< 0.1%
6	5	< 0.1%
7	1	< 0.1%
8	3	< 0.1%
9	3	< 0.1%

Value	Count	Frequency (%)
10000	2	< 0.1%
9999	4	< 0.1%
9998	5	< 0.1%
9997	2	< 0.1%
9996	2	< 0.1%
9993	1	< 0.1%
9992	3	< 0.1%
9990	3	< 0.1%
9989	3	< 0.1%
9988	2	< 0.1%

shares
Real number (ℝ)

Distinct	4986
Distinct (%)	17.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2499.0101

Minimum	0
Maximum	5000
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0
5-th percentile	253
Q1	1242
median	2492
Q3	3765.25
95-th percentile	4757.25
Maximum	5000
Range	5000
Interquartile range (IQR)	2523.25

Descriptive statistics

Standard deviation	1448.8879
Coefficient of variation (CV)	0.57978475
Kurtosis	-1.2132385
Mean	2499.0101
Median Absolute Deviation (MAD)	1259.5
Skewness	0.0085271807
Sum	70562048
Variance	2099276.2
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4820	16	0.1%
1444	16	0.1%
4520	15	0.1%
714	15	0.1%
823	14	< 0.1%
433	14	< 0.1%
558	14	< 0.1%
3932	14	< 0.1%
309	14	< 0.1%
3675	13	< 0.1%
Other values (4976)	28091	99.5%

Value	Count	Frequency (%)
0	3	< 0.1%
1	5	< 0.1%
2	3	< 0.1%
3	4	< 0.1%
4	8	< 0.1%
5	8	< 0.1%
6	9	< 0.1%
7	3	< 0.1%
8	4	< 0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
5000	9	< 0.1%
4999	8	< 0.1%
4998	10	< 0.1%
4997	4	< 0.1%
4996	11	< 0.1%
4995	5	< 0.1%
4994	5	< 0.1%
4993	8	< 0.1%
4992	4	< 0.1%
4991	9	< 0.1%

saves
Real number (ℝ)

High correlation

Distinct	12667
Distinct (%)	44.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7478.1542

Minimum	0
Maximum	15000
Zeros	3
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0
5-th percentile	746.5
Q1	3671.75
median	7467
Q3	11282.25
95-th percentile	14236.5
Maximum	15000
Range	15000
Interquartile range (IQR)	7610.5

Descriptive statistics

Standard deviation	4353.7352
Coefficient of variation (CV)	0.58219383
Kurtosis	-1.2199524
Mean	7478.1542
Median Absolute Deviation (MAD)	3804
Skewness	0.0063909675
Sum	2.1115316 × 10⁸
Variance	18955010
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12676	9	< 0.1%
5574	8	< 0.1%
6181	8	< 0.1%
11330	8	< 0.1%
926	8	< 0.1%
13887	8	< 0.1%
10035	8	< 0.1%
6103	7	< 0.1%
3385	7	< 0.1%
1789	7	< 0.1%
Other values (12657)	28158	99.7%

Value	Count	Frequency (%)
0	3	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	2	< 0.1%
4	4	< 0.1%
5	1	< 0.1%
6	2	< 0.1%
7	2	< 0.1%
8	2	< 0.1%
9	4	< 0.1%

Value	Count	Frequency (%)
15000	2	< 0.1%
14999	4	< 0.1%
14998	2	< 0.1%
14997	2	< 0.1%
14996	3	< 0.1%
14995	2	< 0.1%
14994	2	< 0.1%
14993	1	< 0.1%
14992	4	< 0.1%
14991	1	< 0.1%

reach
Real number (ℝ)

High correlation

Distinct	28036
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1054345.4

Minimum	20913
Maximum	1999865
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	20913
5-th percentile	211500.25
Q1	580626.5
median	1051291
Q3	1525056.2
95-th percentile	1908777.5
Maximum	1999865
Range	1978952
Interquartile range (IQR)	944429.75

Descriptive statistics

Standard deviation	545631.27
Coefficient of variation (CV)	0.51750713
Kurtosis	-1.1863466
Mean	1054345.4
Median Absolute Deviation (MAD)	472670
Skewness	0.0033196577
Sum	2.9770497 × 10¹⁰
Variance	2.9771348 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
834459	3	< 0.1%
791989	2	< 0.1%
939058	2	< 0.1%
1621321	2	< 0.1%
1359807	2	< 0.1%
1611024	2	< 0.1%
145521	2	< 0.1%
961658	2	< 0.1%
1427413	2	< 0.1%
1944126	2	< 0.1%
Other values (28026)	28215	99.9%

Value	Count	Frequency (%)
20913	1	< 0.1%
29995	1	< 0.1%
30314	1	< 0.1%
30608	1	< 0.1%
30615	1	< 0.1%
30902	1	< 0.1%
32483	1	< 0.1%
33270	1	< 0.1%
33274	1	< 0.1%
33541	1	< 0.1%

Value	Count	Frequency (%)
1999865	1	< 0.1%
1999780	1	< 0.1%
1999750	1	< 0.1%
1999744	1	< 0.1%
1999631	1	< 0.1%
1999576	1	< 0.1%
1999543	1	< 0.1%
1999487	1	< 0.1%
1999431	1	< 0.1%
1999305	1	< 0.1%

impressions
Real number (ℝ)

High correlation

Distinct	28035
Distinct (%)	99.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1304714.6

Minimum	31181
Maximum	2497940
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	31181
5-th percentile	415675.75
Q1	832400.25
median	1299030.5
Q3	1776869.2
95-th percentile	2197843.8
Maximum	2497940
Range	2466759
Interquartile range (IQR)	944469

Descriptive statistics

Standard deviation	565667.54
Coefficient of variation (CV)	0.43355655
Kurtosis	-1.0416471
Mean	1304714.6
Median Absolute Deviation (MAD)	472828
Skewness	0.006150288
Sum	3.683992 × 10¹⁰
Variance	3.1997977 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1589220	3	< 0.1%
840985	3	< 0.1%
1936727	3	< 0.1%
977749	3	< 0.1%
1340259	2	< 0.1%
1874618	2	< 0.1%
2047351	2	< 0.1%
2063355	2	< 0.1%
655946	2	< 0.1%
906928	2	< 0.1%
Other values (28025)	28212	99.9%

Value	Count	Frequency (%)
31181	1	< 0.1%
43717	1	< 0.1%
48060	1	< 0.1%
73729	1	< 0.1%
75094	1	< 0.1%
78076	1	< 0.1%
81868	1	< 0.1%
86152	1	< 0.1%
87380	1	< 0.1%
92094	1	< 0.1%

Value	Count	Frequency (%)
2497940	1	< 0.1%
2489252	1	< 0.1%
2485727	1	< 0.1%
2484270	1	< 0.1%
2482212	1	< 0.1%
2480980	1	< 0.1%
2477184	1	< 0.1%
2474793	1	< 0.1%
2473379	1	< 0.1%
2473253	1	< 0.1%

caption_length
Real number (ℝ)

High correlation

Distinct	2201
Distinct (%)	7.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1102.4585

Minimum	0
Maximum	2200
Zeros	15
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0
5-th percentile	107
Q1	555
median	1099.5
Q3	1655
95-th percentile	2091
Maximum	2200
Range	2200
Interquartile range (IQR)	1100

Descriptive statistics

Standard deviation	635.53687
Coefficient of variation (CV)	0.5764724
Kurtosis	-1.1989016
Mean	1102.4585
Median Absolute Deviation (MAD)	550.5
Skewness	-0.0029517995
Sum	31129017
Variance	403907.12
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1787	28	0.1%
1959	25	0.1%
572	25	0.1%
384	25	0.1%
1673	25	0.1%
76	24	0.1%
449	24	0.1%
1034	24	0.1%
592	24	0.1%
1122	23	0.1%
Other values (2191)	27989	99.1%

Value	Count	Frequency (%)
0	15	0.1%
1	14	< 0.1%
2	15	0.1%
3	16	0.1%
4	12	< 0.1%
5	9	< 0.1%
6	18	0.1%
7	11	< 0.1%
8	11	< 0.1%
9	9	< 0.1%

Value	Count	Frequency (%)
2200	13	< 0.1%
2199	13	< 0.1%
2198	9	< 0.1%
2197	18	0.1%
2196	9	< 0.1%
2195	8	< 0.1%
2194	11	< 0.1%
2193	9	< 0.1%
2192	13	< 0.1%
2191	14	< 0.1%

hashtags_count
Real number (ℝ)

High correlation Zeros

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	14.890849

Minimum	0
Maximum	30
Zeros	957
Zeros (%)	3.4%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	7
median	15
Q3	23
95-th percentile	29
Maximum	30
Range	30
Interquartile range (IQR)	16

Descriptive statistics

Standard deviation	9.001764
Coefficient of variation (CV)	0.60451652
Kurtosis	-1.2158726
Mean	14.890849
Median Absolute Deviation (MAD)	8
Skewness	0.018252039
Sum	420458
Variance	81.031755
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
25	966	3.4%
0	957	3.4%
29	953	3.4%
5	950	3.4%
1	942	3.3%
6	936	3.3%
2	936	3.3%
28	936	3.3%
22	934	3.3%
3	928	3.3%
Other values (21)	18798	66.6%

Value	Count	Frequency (%)
0	957	3.4%
1	942	3.3%
2	936	3.3%
3	928	3.3%
4	917	3.2%
5	950	3.4%
6	936	3.3%
7	916	3.2%
8	917	3.2%
9	920	3.3%

Value	Count	Frequency (%)
30	899	3.2%
29	953	3.4%
28	936	3.3%
27	878	3.1%
26	874	3.1%
25	966	3.4%
24	879	3.1%
23	867	3.1%
22	934	3.3%
21	829	2.9%

followers_gained
Real number (ℝ)

Distinct	1001
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	501.66189

Minimum	0
Maximum	1000
Zeros	24
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0
5-th percentile	50
Q1	250
median	500
Q3	755
95-th percentile	951
Maximum	1000
Range	1000
Interquartile range (IQR)	505

Descriptive statistics

Standard deviation	290.43177
Coefficient of variation (CV)	0.57893927
Kurtosis	-1.2149113
Mean	501.66189
Median Absolute Deviation (MAD)	252.5
Skewness	-0.0031426126
Sum	14164925
Variance	84350.611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
752	46	0.2%
398	46	0.2%
138	44	0.2%
470	43	0.2%
328	43	0.2%
841	43	0.2%
951	43	0.2%
667	43	0.2%
918	43	0.2%
985	42	0.1%
Other values (991)	27800	98.5%

Value	Count	Frequency (%)
0	24	0.1%
1	20	0.1%
2	26	0.1%
3	31	0.1%
4	29	0.1%
5	22	0.1%
6	23	0.1%
7	27	0.1%
8	34	0.1%
9	32	0.1%

Value	Count	Frequency (%)
1000	29	0.1%
999	31	0.1%
998	26	0.1%
997	34	0.1%
996	29	0.1%
995	24	0.1%
994	30	0.1%
993	18	0.1%
992	35	0.1%
991	21	0.1%

traffic_source
Categorical

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Home Feed	4773
Hashtags	4752
Reels Feed	4730
External	4713
Profile	4695

Length

Max length	10
Median length	9
Mean length	8.1758394
Min length	7

Characters and Unicode

Total characters	230853
Distinct characters	22
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Reels Feed
2nd row	Hashtags
3rd row	Hashtags
4th row	Explore
5th row	Profile

Common Values

Value	Count	Frequency (%)
Home Feed	4773	16.9%
Hashtags	4752	16.8%
Reels Feed	4730	16.8%
External	4713	16.7%
Profile	4695	16.6%
Explore	4573	16.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
feed	9503	25.2%
home	4773	12.6%
hashtags	4752	12.6%
reels	4730	12.5%
external	4713	12.5%
profile	4695	12.4%
explore	4573	12.1%

Most occurring characters

Value	Count	Frequency (%)
e	47220	20.5%
l	18711	8.1%
s	14234	6.2%
a	14217	6.2%
o	14041	6.1%
r	13981	6.1%
H	9525	4.1%
	9503	4.1%
F	9503	4.1%
d	9503	4.1%
Other values (12)	70415	30.5%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	183611	79.5%
Uppercase Letter	37739	16.3%
Space Separator	9503	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	47220	25.7%
l	18711	10.2%
s	14234	7.8%
a	14217	7.7%
o	14041	7.6%
r	13981	7.6%
d	9503	5.2%
t	9465	5.2%
x	9286	5.1%
m	4773	2.6%
Other values (6)	28180	15.3%

Uppercase Letter

Value	Count	Frequency (%)
H	9525	25.2%
F	9503	25.2%
E	9286	24.6%
R	4730	12.5%
P	4695	12.4%

Space Separator

Value	Count	Frequency (%)
	9503	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	221350	95.9%
Common	9503	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	47220	21.3%
l	18711	8.5%
s	14234	6.4%
a	14217	6.4%
o	14041	6.3%
r	13981	6.3%
H	9525	4.3%
F	9503	4.3%
d	9503	4.3%
t	9465	4.3%
Other values (11)	60950	27.5%

Common

Value	Count	Frequency (%)
	9503	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	230853	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	47220	20.5%
l	18711	8.1%
s	14234	6.2%
a	14217	6.2%
o	14041	6.1%
r	13981	6.1%
H	9525	4.1%
	9503	4.1%
F	9503	4.1%
d	9503	4.1%
Other values (12)	70415	30.5%

content_category
Categorical

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

Fashion	2871
Technology	2860
Food	2842
Photography	2837
Lifestyle	2830
Other values (5)	13996

Length

Max length	11
Median length	9
Mean length	7.108089
Min length	4

Characters and Unicode

Total characters	200704
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Technology
2nd row	Photography
3rd row	Fashion
4th row	Technology
5th row	Photography

Common Values

Value	Count	Frequency (%)
Fashion	2871	10.2%
Technology	2860	10.1%
Food	2842	10.1%
Photography	2837	10.0%
Lifestyle	2830	10.0%
Music	2825	10.0%
Fitness	2811	10.0%
Travel	2807	9.9%
Comedy	2780	9.8%
Beauty	2773	9.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
fashion	2871	10.2%
technology	2860	10.1%
food	2842	10.1%
photography	2837	10.0%
lifestyle	2830	10.0%
music	2825	10.0%
fitness	2811	10.0%
travel	2807	9.9%
comedy	2780	9.8%
beauty	2773	9.8%

Most occurring characters

Value	Count	Frequency (%)
o	22729	11.3%
e	19691	9.8%
s	14148	7.0%
y	14080	7.0%
h	11405	5.7%
i	11337	5.6%
a	11288	5.6%
t	11251	5.6%
n	8542	4.3%
F	8524	4.2%
Other values (16)	67709	33.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	172468	85.9%
Uppercase Letter	28236	14.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	22729	13.2%
e	19691	11.4%
s	14148	8.2%
y	14080	8.2%
h	11405	6.6%
i	11337	6.6%
a	11288	6.5%
t	11251	6.5%
n	8542	5.0%
l	8497	4.9%
Other values (9)	39500	22.9%

Uppercase Letter

Value	Count	Frequency (%)
F	8524	30.2%
T	5667	20.1%
P	2837	10.0%
L	2830	10.0%
M	2825	10.0%
C	2780	9.8%
B	2773	9.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	200704	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	22729	11.3%
e	19691	9.8%
s	14148	7.0%
y	14080	7.0%
h	11405	5.7%
i	11337	5.6%
a	11288	5.6%
t	11251	5.6%
n	8542	4.3%
F	8524	4.2%
Other values (16)	67709	33.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	200704	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	22729	11.3%
e	19691	9.8%
s	14148	7.0%
y	14080	7.0%
h	11405	5.7%
i	11337	5.6%
a	11288	5.6%
t	11251	5.6%
n	8542	4.3%
F	8524	4.2%
Other values (16)	67709	33.7%

account_id
Text

Distinct	300
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	1.8 MiB

Length

Max length	11
Median length	11
Mean length	11
Min length	11

Characters and Unicode

Total characters	310596
Distinct characters	17
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	creator_135
2nd row	creator_109
3rd row	creator_135
4th row	creator_271
5th row	creator_223

Value	Count	Frequency (%)
creator_152	114	0.4%
creator_076	114	0.4%
creator_267	114	0.4%
creator_195	113	0.4%
creator_171	113	0.4%
creator_020	113	0.4%
creator_120	113	0.4%
creator_013	113	0.4%
creator_223	113	0.4%
creator_164	112	0.4%
Other values (290)	27104	96.0%

Most occurring characters

Value	Count	Frequency (%)
r	56472	18.2%
c	28236	9.1%
e	28236	9.1%
a	28236	9.1%
t	28236	9.1%
o	28236	9.1%
_	28236	9.1%
2	15325	4.9%
1	15111	4.9%
0	14862	4.8%
Other values (7)	39410	12.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	197652	63.6%
Decimal Number	84708	27.3%
Connector Punctuation	28236	9.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	15325	18.1%
1	15111	17.8%
0	14862	17.5%
3	5737	6.8%
9	5709	6.7%
6	5667	6.7%
5	5644	6.7%
8	5630	6.6%
7	5520	6.5%
4	5503	6.5%

Lowercase Letter

Value	Count	Frequency (%)
r	56472	28.6%
c	28236	14.3%
e	28236	14.3%
a	28236	14.3%
t	28236	14.3%
o	28236	14.3%

Connector Punctuation

Value	Count	Frequency (%)
_	28236	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	197652	63.6%
Common	112944	36.4%

Most frequent character per script

Common

Value	Count	Frequency (%)
_	28236	25.0%
2	15325	13.6%
1	15111	13.4%
0	14862	13.2%
3	5737	5.1%
9	5709	5.1%
6	5667	5.0%
5	5644	5.0%
8	5630	5.0%
7	5520	4.9%

Latin

Value	Count	Frequency (%)
r	56472	28.6%
c	28236	14.3%
e	28236	14.3%
a	28236	14.3%
t	28236	14.3%
o	28236	14.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	310596	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
r	56472	18.2%
c	28236	9.1%
e	28236	9.1%
a	28236	9.1%
t	28236	9.1%
o	28236	9.1%
_	28236	9.1%
2	15325	4.9%
1	15111	4.9%
0	14862	4.8%
Other values (7)	39410	12.7%

followers_count_before_post
Real number (ℝ)

High correlation

Distinct	24347
Distinct (%)	86.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	54126.576

Minimum	5000
Maximum	165591
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	5000
5-th percentile	12391.75
Q1	30672.75
median	46936.5
Q3	68475.25
95-th percentile	126044
Maximum	165591
Range	160591
Interquartile range (IQR)	37802.5

Descriptive statistics

Standard deviation	33246.39
Coefficient of variation (CV)	0.61423413
Kurtosis	0.47962318
Mean	54126.576
Median Absolute Deviation (MAD)	18272
Skewness	1.0013824
Sum	1.528318 × 10⁹
Variance	1.1053225 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	90	0.3%
15000	65	0.2%
30000	62	0.2%
60000	30	0.1%
100000	28	0.1%
38893	4	< 0.1%
51053	4	< 0.1%
43790	4	< 0.1%
54526	4	< 0.1%
35347	4	< 0.1%
Other values (24337)	27941	99.0%

Value	Count	Frequency (%)
5000	90	0.3%
5007	1	< 0.1%
5011	1	< 0.1%
5012	1	< 0.1%
5013	1	< 0.1%
5018	1	< 0.1%
5031	1	< 0.1%
5037	1	< 0.1%
5047	1	< 0.1%
5074	1	< 0.1%

Value	Count	Frequency (%)
165591	1	< 0.1%
165070	1	< 0.1%
165000	1	< 0.1%
164652	1	< 0.1%
163712	1	< 0.1%
162919	1	< 0.1%
162663	1	< 0.1%
162516	1	< 0.1%
162038	1	< 0.1%
161384	1	< 0.1%

engagement_rate
Real number (ℝ)

High correlation

Distinct	27954
Distinct (%)	99.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.2793771

Minimum	0.055498861
Maximum	21.070199
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	0.055498861
5-th percentile	0.40863036
Q1	1.1629225
median	2.2162619
Q3	3.9690757
95-th percentile	10.026687
Maximum	21.070199
Range	21.0147
Interquartile range (IQR)	2.8061531

Descriptive statistics

Standard deviation	3.5170442
Coefficient of variation (CV)	1.0724732
Kurtosis	9.0744043
Mean	3.2793771
Median Absolute Deviation (MAD)	1.2490315
Skewness	2.7353563
Sum	92596.493
Variance	12.3696
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21.07019931	283	1.0%
2.698758164	1	< 0.1%
2.21431915	1	< 0.1%
3.031728835	1	< 0.1%
1.6501105	1	< 0.1%
1.415171879	1	< 0.1%
1.949481701	1	< 0.1%
1.838752047	1	< 0.1%
0.551111048	1	< 0.1%
0.7748799596	1	< 0.1%
Other values (27944)	27944	99.0%

Value	Count	Frequency (%)
0.05549886118	1	< 0.1%
0.05844464515	1	< 0.1%
0.06048152056	1	< 0.1%
0.06680675873	1	< 0.1%
0.06720189688	1	< 0.1%
0.07165568495	1	< 0.1%
0.0765918876	1	< 0.1%
0.07785253064	1	< 0.1%
0.08109450438	1	< 0.1%
0.08206871434	1	< 0.1%

Value	Count	Frequency (%)
21.07019931	283	1.0%
21.0685624	1	< 0.1%
21.05404384	1	< 0.1%
21.05316995	1	< 0.1%
21.02699773	1	< 0.1%
21.02656546	1	< 0.1%
21.00823402	1	< 0.1%
21.00453878	1	< 0.1%
20.95667082	1	< 0.1%
20.9330855	1	< 0.1%

post_hour
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

9	28236

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	28236
Distinct characters	1
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	9
2nd row	9
3rd row	9
4th row	9
5th row	9

Common Values

Value	Count	Frequency (%)
9	28236	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
9	28236	100.0%

Most occurring characters

Value	Count	Frequency (%)
9	28236	100.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	28236	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
9	28236	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	28236	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
9	28236	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	28236	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
9	28236	100.0%

post_day
Categorical

High correlation

Distinct	7
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 MiB

Thursday	4103
Tuesday	4102
Wednesday	4069
Monday	4041
Saturday	3992
Other values (2)	7929

Length

Max length	9
Median length	8
Mean length	7.1509775
Min length	6

Characters and Unicode

Total characters	201915
Distinct characters	17
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Friday
2nd row	Saturday
3rd row	Friday
4th row	Thursday
5th row	Friday

Common Values

Value	Count	Frequency (%)
Thursday	4103	14.5%
Tuesday	4102	14.5%
Wednesday	4069	14.4%
Monday	4041	14.3%
Saturday	3992	14.1%
Sunday	3970	14.1%
Friday	3959	14.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
thursday	4103	14.5%
tuesday	4102	14.5%
wednesday	4069	14.4%
monday	4041	14.3%
saturday	3992	14.1%
sunday	3970	14.1%
friday	3959	14.0%

Most occurring characters

Value	Count	Frequency (%)
d	32305	16.0%
a	32228	16.0%
y	28236	14.0%
u	16167	8.0%
s	12274	6.1%
e	12240	6.1%
n	12080	6.0%
r	12054	6.0%
T	8205	4.1%
S	7962	3.9%
Other values (7)	28164	13.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	173679	86.0%
Uppercase Letter	28236	14.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
d	32305	18.6%
a	32228	18.6%
y	28236	16.3%
u	16167	9.3%
s	12274	7.1%
e	12240	7.0%
n	12080	7.0%
r	12054	6.9%
h	4103	2.4%
o	4041	2.3%
Other values (2)	7951	4.6%

Uppercase Letter

Value	Count	Frequency (%)
T	8205	29.1%
S	7962	28.2%
W	4069	14.4%
M	4041	14.3%
F	3959	14.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	201915	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
d	32305	16.0%
a	32228	16.0%
y	28236	14.0%
u	16167	8.0%
s	12274	6.1%
e	12240	6.1%
n	12080	6.0%
r	12054	6.0%
T	8205	4.1%
S	7962	3.9%
Other values (7)	28164	13.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	201915	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
d	32305	16.0%
a	32228	16.0%
y	28236	14.0%
u	16167	8.0%
s	12274	6.1%
e	12240	6.1%
n	12080	6.0%
r	12054	6.0%
T	8205	4.1%
S	7962	3.9%
Other values (7)	28164	13.9%

is_weekend
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	248.2 KiB

False	20274
True	7962

Value	Count	Frequency (%)
False	20274	71.8%
True	7962	28.2%

has_high_hashtags
Boolean

High correlation

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	248.2 KiB

True	18917
False	9319

Value	Count	Frequency (%)
True	18917	67.0%
False	9319	33.0%

long_caption
Boolean

High correlation Imbalance

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	248.2 KiB

True	26299
False	1937

Value	Count	Frequency (%)
True	26299	93.1%
False	1937	6.9%

high_intent_engagement
Real number (ℝ)

High correlation

Distinct	13962
Distinct (%)	49.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9977.1642

Minimum	124
Maximum	19965
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	441.2 KiB

Quantile statistics

Minimum	124
5-th percentile	2676
Q1	6134.75
median	9993.5
Q3	13751.5
95-th percentile	17299.25
Maximum	19965
Range	19841
Interquartile range (IQR)	7616.75

Descriptive statistics

Standard deviation	4595.4393
Coefficient of variation (CV)	0.46059574
Kurtosis	-0.99778728
Mean	9977.1642
Median Absolute Deviation (MAD)	3800.5
Skewness	0.0063425592
Sum	2.8171521 × 10⁸
Variance	21118063
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11582	9	< 0.1%
14476	9	< 0.1%
8893	9	< 0.1%
5451	8	< 0.1%
8496	8	< 0.1%
10479	8	< 0.1%
12395	8	< 0.1%
15735	8	< 0.1%
6581	8	< 0.1%
10144	7	< 0.1%
Other values (13952)	28154	99.7%

Value	Count	Frequency (%)
124	1	< 0.1%
131	1	< 0.1%
138	1	< 0.1%
139	1	< 0.1%
178	1	< 0.1%
180	1	< 0.1%
189	1	< 0.1%
199	1	< 0.1%
200	1	< 0.1%
253	1	< 0.1%

Value	Count	Frequency (%)
19965	1	< 0.1%
19933	1	< 0.1%
19925	1	< 0.1%
19881	1	< 0.1%
19872	1	< 0.1%
19842	1	< 0.1%
19808	1	< 0.1%
19800	1	< 0.1%
19792	1	< 0.1%
19781	1	< 0.1%

follower_bucket
Categorical

High correlation Uniform

Distinct	4
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	248.6 KiB

Small	7059
Medium	7059
Large	7059
Very Large	7059

Length

Max length	10
Median length	8
Mean length	6.5
Min length	5

Characters and Unicode

Total characters	183534
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Large
2nd row	Small
3rd row	Very Large
4th row	Very Large
5th row	Very Large

Common Values

Value	Count	Frequency (%)
Small	7059	25.0%
Medium	7059	25.0%
Large	7059	25.0%
Very Large	7059	25.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
large	14118	40.0%
small	7059	20.0%
medium	7059	20.0%
very	7059	20.0%

Most occurring characters

Value	Count	Frequency (%)
e	28236	15.4%
a	21177	11.5%
r	21177	11.5%
m	14118	7.7%
l	14118	7.7%
L	14118	7.7%
g	14118	7.7%
S	7059	3.8%
M	7059	3.8%
d	7059	3.8%
Other values (5)	35295	19.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	141180	76.9%
Uppercase Letter	35295	19.2%
Space Separator	7059	3.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	28236	20.0%
a	21177	15.0%
r	21177	15.0%
m	14118	10.0%
l	14118	10.0%
g	14118	10.0%
d	7059	5.0%
i	7059	5.0%
u	7059	5.0%
y	7059	5.0%

Uppercase Letter

Value	Count	Frequency (%)
L	14118	40.0%
S	7059	20.0%
M	7059	20.0%
V	7059	20.0%

Space Separator

Value	Count	Frequency (%)
	7059	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	176475	96.2%
Common	7059	3.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	28236	16.0%
a	21177	12.0%
r	21177	12.0%
m	14118	8.0%
l	14118	8.0%
L	14118	8.0%
g	14118	8.0%
S	7059	4.0%
M	7059	4.0%
d	7059	4.0%
Other values (4)	28236	16.0%

Common

Value	Count	Frequency (%)
	7059	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	183534	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	28236	15.4%
a	21177	11.5%
r	21177	11.5%
m	14118	7.7%
l	14118	7.7%
L	14118	7.7%
g	14118	7.7%
S	7059	3.8%
M	7059	3.8%
d	7059	3.8%
Other values (5)	35295	19.2%

Interactions

Correlations

	caption_length	comments	content_category	engagement_rate	follower_bucket	followers_count_before_post	followers_gained	has_high_hashtags	hashtags_count	high_intent_engagement	impressions	is_weekend	likes	long_caption	media_type	post_day	reach	saves	shares	traffic_source
caption_length	1.000	-0.009	0.005	-0.002	0.008	0.002	-0.002	0.000	0.004	0.010	-0.006	0.008	0.001	0.809	0.000	0.000	-0.005	0.010	0.003	0.000
comments	-0.009	1.000	0.003	0.032	0.000	0.005	0.002	0.006	0.008	-0.004	0.002	0.000	-0.002	0.012	0.012	0.000	-0.000	-0.004	-0.006	0.000
content_category	0.005	0.003	1.000	0.000	0.000	0.004	0.006	0.014	0.007	0.000	0.009	0.008	0.004	0.016	0.008	0.000	0.008	0.007	0.000	0.004
engagement_rate	-0.002	0.032	0.000	1.000	0.466	-0.689	0.001	0.003	-0.004	0.061	0.036	0.000	0.671	0.000	0.000	0.000	0.040	0.057	0.026	0.000
follower_bucket	0.008	0.000	0.000	0.466	1.000	0.834	0.008	0.006	0.011	0.006	0.000	0.000	0.000	0.003	0.005	0.000	0.000	0.007	0.000	0.000
followers_count_before_post	0.002	0.005	0.004	-0.689	0.834	1.000	-0.005	0.000	0.004	-0.008	-0.002	0.007	0.001	0.000	0.000	0.004	-0.003	-0.008	-0.004	0.010
followers_gained	-0.002	0.002	0.006	0.001	0.008	-0.005	1.000	0.004	0.008	0.002	-0.000	0.008	-0.006	0.002	0.001	0.000	0.000	0.000	0.005	0.009
has_high_hashtags	0.000	0.006	0.014	0.003	0.006	0.000	0.004	1.000	1.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.000	0.009
hashtags_count	0.004	0.008	0.007	-0.004	0.011	0.004	0.008	1.000	1.000	-0.003	-0.004	0.002	-0.001	0.000	0.000	0.009	-0.006	-0.001	-0.005	0.000
high_intent_engagement	0.010	-0.004	0.000	0.061	0.006	-0.008	0.002	0.000	-0.003	1.000	0.005	0.000	-0.001	0.000	0.006	0.007	0.005	0.952	0.304	0.000
impressions	-0.006	0.002	0.009	0.036	0.000	-0.002	-0.000	0.000	-0.004	0.005	1.000	0.009	0.049	0.008	0.000	0.008	0.969	0.008	-0.008	0.000
is_weekend	0.008	0.000	0.008	0.000	0.000	0.007	0.008	0.000	0.002	0.000	0.009	1.000	0.008	0.000	0.000	1.000	0.000	0.004	0.000	0.000
likes	0.001	-0.002	0.004	0.671	0.000	0.001	-0.006	0.000	-0.001	-0.001	0.049	0.008	1.000	0.000	0.000	0.003	0.054	-0.003	0.006	0.000
long_caption	0.809	0.012	0.016	0.000	0.003	0.000	0.002	0.000	0.000	0.000	0.008	0.000	0.000	1.000	0.000	0.000	0.004	0.018	0.000	0.000
media_type	0.000	0.012	0.008	0.000	0.005	0.000	0.001	0.000	0.000	0.006	0.000	0.000	0.000	0.000	1.000	0.000	0.011	0.000	0.000	0.002
post_day	0.000	0.000	0.000	0.000	0.000	0.004	0.000	0.000	0.009	0.007	0.008	1.000	0.003	0.000	0.000	1.000	0.007	0.007	0.000	0.000
reach	-0.005	-0.000	0.008	0.040	0.000	-0.003	0.000	0.000	-0.006	0.005	0.969	0.000	0.054	0.004	0.011	0.007	1.000	0.007	-0.006	0.000
saves	0.010	-0.004	0.007	0.057	0.007	-0.008	0.000	0.000	-0.001	0.952	0.008	0.004	-0.003	0.018	0.000	0.007	0.007	1.000	0.005	0.000
shares	0.003	-0.006	0.000	0.026	0.000	-0.004	0.005	0.000	-0.005	0.304	-0.008	0.000	0.006	0.000	0.000	0.000	-0.006	0.005	1.000	0.000
traffic_source	0.000	0.000	0.004	0.000	0.000	0.010	0.009	0.009	0.000	0.000	0.000	0.000	0.000	0.000	0.002	0.000	0.000	0.000	0.000	1.000

Missing values

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

	post_id	upload_date	media_type	likes	comments	shares	saves	reach	impressions	caption_length	hashtags_count	followers_gained	traffic_source	content_category	account_id	followers_count_before_post	engagement_rate	post_hour	post_day	is_weekend	has_high_hashtags	long_caption	high_intent_engagement	follower_bucket
1	IG0013402	2025-04-04 09:25:22.954916	Reel	132420	5003	3667	5601	1546640	2016802	1750	6	171	Reels Feed	Technology	creator_135	54355	2.698758	9	Friday	False	False	True	9268	Large
2	IG0010751	2025-04-19 09:25:22.954916	Video	31476	6754	4382	12891	1916933	2079234	1502	26	892	Hashtags	Photography	creator_109	26763	2.073871	9	Saturday	True	True	True	17273	Small
3	IG0013361	2025-08-15 09:25:22.954916	Video	94556	9750	1667	10965	1451049	1816268	626	27	530	Hashtags	Fashion	creator_135	71457	1.636481	9	Friday	False	True	True	12632	Very Large
4	IG0027034	2025-02-27 09:25:22.954916	Video	38105	1743	4306	2341	1240598	1707533	1131	16	289	Explore	Technology	creator_271	119968	0.387562	9	Thursday	False	True	True	6647	Very Large
5	IG0022212	2025-09-05 09:25:22.954916	Carousel	113141	9477	3079	310	496673	690055	26	4	604	Profile	Photography	creator_223	76806	1.640588	9	Friday	False	False	False	3389	Very Large
6	IG0027062	2024-11-25 09:25:22.954916	Video	39301	9597	763	369	222449	692071	447	25	295	Reels Feed	Photography	creator_271	102513	0.488036	9	Monday	False	True	True	1132	Very Large
8	IG0021589	2025-09-03 09:25:22.954916	Photo	60627	2747	3371	4244	841674	860179	1397	12	550	External	Technology	creator_218	78277	0.906895	9	Wednesday	False	True	True	7615	Very Large
9	IG0012768	2025-03-30 09:25:22.954916	Video	171776	8005	3337	837	1637998	2055998	837	12	16	Home Feed	Fitness	creator_129	27157	6.773760	9	Sunday	True	True	True	4174	Small
10	IG0000281	2024-11-20 09:25:22.954916	Reel	198491	9045	3079	2494	867699	1035039	697	2	59	Home Feed	Lifestyle	creator_003	60237	3.537842	9	Wednesday	False	False	True	5573	Large
11	IG0013175	2025-08-29 09:25:22.954916	Reel	148808	9378	2526	3553	667898	769902	42	9	229	Hashtags	Beauty	creator_133	66403	2.473759	9	Friday	False	False	False	6079	Large

	post_id	upload_date	media_type	likes	comments	shares	saves	reach	impressions	caption_length	hashtags_count	followers_gained	traffic_source	content_category	account_id	followers_count_before_post	engagement_rate	post_hour	post_day	is_weekend	has_high_hashtags	long_caption	high_intent_engagement	follower_bucket
29989	IG0028299	2025-02-11 09:25:22.954916	Photo	188915	9134	1882	12575	1802319	2192918	564	22	263	Home Feed	Technology	creator_284	43076	4.933281	9	Tuesday	False	True	True	14457	Medium
29990	IG0013601	2025-09-30 09:25:22.954916	Reel	127391	6906	1700	8309	1004168	1084976	992	18	124	External	Travel	creator_137	84575	1.706249	9	Tuesday	False	True	True	10009	Very Large
29991	IG0029852	2025-02-14 09:25:22.954916	Reel	59163	1247	4164	766	601563	1002391	121	0	732	Explore	Food	creator_299	18341	3.562510	9	Friday	False	False	False	4930	Small
29992	IG0008746	2025-11-19 09:25:22.954916	Reel	50519	2735	3583	7246	1792483	2024162	2112	1	737	Explore	Fashion	creator_090	90126	0.711038	9	Wednesday	False	False	True	10829	Very Large
29993	IG0023022	2025-11-17 09:25:22.954916	Reel	179400	811	1945	2002	1579492	1801785	176	13	51	Home Feed	Comedy	creator_231	158125	1.164636	9	Monday	False	True	True	3947	Very Large
29994	IG0019653	2024-12-12 09:25:22.954916	Carousel	137702	6968	2848	3634	1447382	1873828	271	16	430	Reels Feed	Fashion	creator_198	65898	2.293727	9	Thursday	False	True	True	6482	Large
29995	IG0013079	2024-12-12 09:25:22.954916	Carousel	150118	6943	108	4787	977351	1229434	1506	18	300	External	Beauty	creator_132	9902	16.355888	9	Thursday	False	True	True	4895	Small
29996	IG0001698	2025-07-21 09:25:22.954916	Reel	66131	2789	2410	6048	1090867	1561926	1956	25	178	Explore	Fitness	creator_017	85014	0.910179	9	Monday	False	True	True	8458	Very Large
29997	IG0010959	2025-03-19 09:25:22.954916	Reel	81369	7822	552	14862	449706	850597	85	19	78	Reels Feed	Food	creator_111	26057	4.014468	9	Wednesday	False	True	False	15414	Small
29998	IG0024084	2025-10-07 09:25:22.954916	Video	75694	8697	2485	6541	402361	644327	1323	26	960	Reels Feed	Travel	creator_242	59044	1.582159	9	Tuesday	False	True	True	9026	Large

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Uppercase Letter

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Lowercase Letter

Connector Punctuation

Most occurring scripts

Most frequent character per script

Common

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script